1001 Secrets for Windows NT Registry
(Publisher: 29th Street Press)
Author(s): Tim Daniels
ISBN: 1882419685
Publication Date: 12/01/97

Previous Table of Contents Next


If the “Move selection after Enter” function is enabled, this value controls the direction the selection cursor moves after you press Enter in the current cell. Valid values are

0 Down
1 Right
2 Up
3 Left

IV-25 Hive: HKEY_CURRENT_USER
Key: Software\Microsoft\Office\8.0\Excel\Microsoft Excel
Value Name: DefFileMRU
Data Type: REG_DWORD
Value: 0x4

This value controls the number of most recently used files to display under the File Menu.

IV-26 Hive: HKEY_CURRENT_USER
Key: Software\Microsoft\Office\8.0\Excel\Microsoft Excel
Value Name: Font
Data Type: REG_SZ
Value: Arial,10

This value specifics the default font and size to use for new worksheets. It also controls the default font used for the Normal style and for the row and column headings.

IV-27 Hive: HKEY_CURRENT_USER
Key: Software\Microsoft\Office\8.0\Excel\Microsoft Excel
Value Name: MenuKey
Data Type: REG_DWORD
Value: 47

This value specifies the key to use to activate Excel menus or Help functions; normally this value is a forward slash (/), which is the menu key used for Lotus 1-2-3. This is the value of the key in ASCII.

IV-28 Hive: HKEY_CURRENT_USER
Key: Software\Microsoft\Office\8.0\Excel\Microsoft Excel
Value Name: Randomize
Data Type: REG_DWORD
Value: 1

This value causes Microsoft Excel to generate a unique random number each time you use the RAND function.

IV-29 The next two registry keys control where Excel’s dialog boxes appear on the screen. Excel updates these values when it closes.

Hive: HKEY_CURRENT_USER
Key: Software\Microsoft\Office\8.0\Excel\Microsoft Excel
Value Name: StickyPtX
Data Type: REG_DWORD
Value: 479

IV-30 Hive: HKEY_CURRENT_USER
Key: Software\Microsoft\Office\8.0\Excel\Microsoft Excel
Value Name: StickyPtY
Data Type: REG_DWORD
Value: 241

IV-31 Hive: HKEY_CURRENT_USER
Key: Software\Microsoft\Office\8.0\Excel\Microsoft Excel
Value Name: SortCaseSensitive
Data Type: REG_DWORD
Value: 0x0

This value controls the default Case Sensitive setting for the sorting algorithm that Microsoft Excel uses.

IV-32 Hive: HKEY_CURRENT_USER
Key: Software\Microsoft\Office\8.0\Excel\Microsoft Excel
Value Name: CustomSortOrder
Data Type: REG_DWORD
Value: 0x0

This value controls the default setting of the First key sort order, which appears under the Sort/Options dialog box.

IV-33 Hive: HKEY_CURRENT_USER
Key: Software\Microsoft\Office\8.0\Excel\Microsoft Excel
Value Name: AutoFormat
Data Type: REG_DWORD
Value: 0x2

This value is the default AutoFormat choice that appears under the AutoFormat dialog box. The value specifies an index number that points to a Table Format.

IV-34 Hive: HKEY_CURRENT_USER
Key: Software\Microsoft\Office\8.0\Excel\Microsoft Excel
Value Name: AutoFormat Options
Data Type: REG_DWORD
Value: 0x3f (63)

This value controls the format options specified in the AutoFormat registry key; the options correspond to the attributes in the AutoFormat dialog box. The available options are

1 Number
2 Font
4 Alignment
8 Border
16 Patterns
32 Width/Height


Previous Table of Contents Next